<?php

namespace App\Http\Controllers;

use App\Models\Invoice;
use Illuminate\Http\Request;
use Yajra\DataTables\Facades\DataTables;

class InvoiceController extends Controller
{
    /**
     * Display a listing of the resource.
     */
    public function index(Request $request)
    {
        if ($request->ajax()) {
            $search_keyword = '';
            $status = 'all'; // all status
            $request_data = $request->all();
            if ($request->has('search_keyword')) {
                $search_keyword = $request->search_keyword;
            }

            // avoid zero column as it's checkbox so we can't sort by it
            if ($request->has('order') && $request->order[0]['column'] != 0) {
                $sort_column_number = $request->order[0]['column'];
                $sort_column_dir = $request->order[0]['dir'];
                $sort_column_key = $request->columns[$sort_column_number]['data'];
            }

            $main_query = Invoice::query();
            $query = $main_query;
            if (!empty($search_keyword)) {
                $query = $query->where('status', 'LIKE', '%' . $search_keyword . '%');
            }

            if (!empty($sort_column_key)) {
                $query = $query->orderBy($sort_column_key, $sort_column_dir);
            } else {
                $query = $query->latest();
            }

            $data = $query->get();
            $count_total = $main_query->count();
            $count_filter = $count_total;
            return DataTables::of($data)

                ->addColumn('invoice_number', function ($row) {
                    return $row->invoice_number;
                })
                ->addColumn('invoice_date', function ($row) {
                    return formatDate($row->invoice_date, 'Y/m/d H:i:s');
                })
                ->addColumn('due_date', function ($row) {
                    return formatDate($row->due_date, 'Y/m/d H:i:s');
                })
                ->addColumn('payment_modes', function ($row) {
                    return $row->payment_modes;
                })
                ->addColumn('generated_by', function ($row) {
                    return $row->generated_by_user->first_name . $row->generated_by_user->last_name;
                })
                ->editColumn('status', function ($row) {

                    return $row->status;
                })
                ->addColumn('action', function ($row) {

                    if ($row->is_admin !== 1) {

                        return view('users.invoice.partially.delete', compact('row'));
                    }
                })
                ->rawColumns(['action', 'status'])
                ->with([
                    "recordsTotal"    => $count_total,
                    "recordsFiltered" => $count_filter,
                ])
                ->make(true);
        }
        return view('users.invoice.index');
    }

    /**
     * Show the form for creating a new resource.
     */
    public function create()
    {
        return view('users.invoice.create');
    }

    /**
     * Store a newly created resource in storage.
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     */
    public function show(string $id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     */
    public function edit(string $id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     */
    public function update(Request $request, string $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     */
    public function destroy(string $id)
    {
        //
    }
}